package com.wmh.baseservice.operationaid.entity;

import com.baomidou.mybatisplus.annotation.*;
import java.io.Serializable;

import java.math.BigDecimal;
import lombok.Data;
import lombok.experimental.Accessors;
import java.time.LocalDateTime;

/**
 *
 * @author 牛威龙
 * @TableName operation_aid_product_details
 * @createDate 2023-09-07 15:45:59
 */
@Data
@Accessors(chain = true)
@TableName("operation_aid_product_details")
public class ProductDetails implements Serializable {

    /**
     * 主键
     */
    @TableId(value = COL_ID ,type = IdType.AUTO)
    private Long id;

    /**
     * 店铺名称
     */
    @TableField(value = COL_STORE_NAME)
    private String storeName;

    /**
     * 数据日期
     */
    @TableField(value = COL_DATA_CYCLE)
    private String dataCycle;

    /**
     * 商品名称
     */
    @TableField(value = COL_PRODUCT_NAME)
    private String productName;

    /**
     * 商品id
     */
    @TableField(value = COL_PRODUCT_ID)
    private Long productId;

    /**
     * 类目名称
     */
    @TableField(value = COL_CATEGORY_NAME)
    private String categoryName;

    /**
     * 商品访客数
     */
    @TableField(value = COL_PRODUCT_VISITOR_NUMS)
    private Integer productVisitorNums;

    /**
     * 商品浏览量
     */
    @TableField(value = COL_PRODUCT_BROWSE_NUMS)
    private Integer productBrowseNums;

    /**
     * 支付件数
     */
    @TableField(value = COL_PAYMENT_NUMS)
    private Integer paymentNums;

    /**
     * 支付买家数
     */
    @TableField(value = COL_PAYMENT_BUYER_NUMS)
    private Integer paymentBuyerNums;

    /**
     * 支付订单数
     */
    @TableField(value = COL_PAYMENT_ORDER_NUMS)
    private Integer paymentOrderNums;

    /**
     * 交易金额
     */
    @TableField(value = COL_TRANSACTION_AMOUNT)
    private BigDecimal transactionAmount;

    /**
     * 下单人数
     */
    @TableField(value = COL_ORDER_NUMBER_OF_PEOPLE)
    private Integer orderNumberOfPeople;

    /**
     * 支付转化率
     */
    @TableField(value = COL_PAYMENT_CONVERSION_RATE)
    private BigDecimal paymentConversionRate;

    /**
     * 下单率
     */
    @TableField(value = COL_PLACE_ORDER_RATE)
    private BigDecimal placeOrderRate;

    /**
     * 支付率
     */
    @TableField(value = COL_PAYOUT_RATE)
    private BigDecimal payoutRate;

    /**
     * 商品收藏用户数
     */
    @TableField(value = COL_PRODUCT_COLLECTION_NUMS)
    private Integer productCollectionNums;

    /**
     * 成团订单数
     */
    @TableField(value = COL_NUMBER_OF_GROUP_ORDERS)
    private Integer numberOfGroupOrders;

    /**
     * 商品成团件数
     */
    @TableField(value = COL_PRODUCT_GROUP_NUMS)
    private Integer productGroupNums;

    /**
     * UV价值
     */
    @TableField(value = COL_UV_VALUE)
    private BigDecimal uvValue;

    /**
     * 客单价
     */
    @TableField(value = COL_CUSTOMER_UNIT_PRICE)
    private BigDecimal customerUnitPrice;

    /**
     * 收藏率
     */
    @TableField(value = COL_COLLECTION_RATE)
    private BigDecimal collectionRate;

    /**
     * 商品求助平台率
     */
    @TableField(value = COL_PRODUCT_HELP_PLATFORM_RATE)
    private BigDecimal productHelpPlatformRate;

    /**
     * 创建时间
     */
    @TableField(value = COL_CREATE_TIME)
    private LocalDateTime createTime;

    /**
     * 修改时间
     */
    @TableField(value = COL_UPDATE_TIME)
    private LocalDateTime updateTime;

    /**
     * 是否删除 0 未删除 1 已删除
     */
    @TableField(value = COL_DELETED)
    @TableLogic
    private Integer deleted;


    /**
     * 主键
     */
    public static final String COL_ID = "id";

    /**
     * 店铺名称
     */
    public static final String COL_STORE_NAME = "store_name";

    /**
     * 数据日期
     */
    public static final String COL_DATA_CYCLE = "data_cycle";

    /**
     * 商品名称
     */
    public static final String COL_PRODUCT_NAME = "product_name";

    /**
     * 商品id
     */
    public static final String COL_PRODUCT_ID = "product_id";

    /**
     * 类目名称
     */
    public static final String COL_CATEGORY_NAME = "category_name";

    /**
     * 商品访客数
     */
    public static final String COL_PRODUCT_VISITOR_NUMS = "product_visitor_nums";

    /**
     * 商品浏览量
     */
    public static final String COL_PRODUCT_BROWSE_NUMS = "product_browse_nums";

    /**
     * 支付件数
     */
    public static final String COL_PAYMENT_NUMS = "payment_nums";

    /**
     * 支付买家数
     */
    public static final String COL_PAYMENT_BUYER_NUMS = "payment_buyer_nums";

    /**
     * 支付订单数
     */
    public static final String COL_PAYMENT_ORDER_NUMS = "payment_order_nums";

    /**
     * 交易金额
     */
    public static final String COL_TRANSACTION_AMOUNT = "transaction_amount";

    /**
     * 下单人数
     */
    public static final String COL_ORDER_NUMBER_OF_PEOPLE = "order_number_of_people";

    /**
     * 支付转化率
     */
    public static final String COL_PAYMENT_CONVERSION_RATE = "payment_conversion_rate";

    /**
     * 下单率
     */
    public static final String COL_PLACE_ORDER_RATE = "place_order_rate";

    /**
     * 支付率
     */
    public static final String COL_PAYOUT_RATE = "payout_rate";

    /**
     * 商品收藏用户数
     */
    public static final String COL_PRODUCT_COLLECTION_NUMS = "product_collection_nums";

    /**
     * 成团订单数
     */
    public static final String COL_NUMBER_OF_GROUP_ORDERS = "number_of_group_orders";

    /**
     * 商品成团件数
     */
    public static final String COL_PRODUCT_GROUP_NUMS = "product_group_nums";

    /**
     * UV价值
     */
    public static final String COL_UV_VALUE = "uv_value";

    /**
     * 客单价
     */
    public static final String COL_CUSTOMER_UNIT_PRICE = "customer_unit_price";

    /**
     * 收藏率
     */
    public static final String COL_COLLECTION_RATE = "collection_rate";

    /**
     * 商品求助平台率
     */
    public static final String COL_PRODUCT_HELP_PLATFORM_RATE = "product_help_platform_rate";

    /**
     * 创建时间
     */
    public static final String COL_CREATE_TIME = "create_time";

    /**
     * 修改时间
     */
    public static final String COL_UPDATE_TIME = "update_time";

    /**
     * 是否删除 0 未删除 1 已删除
     */
    public static final String COL_DELETED = "deleted";

    @TableField(exist = false)
    static final long serialVersionUID = 1L;
}
